package com.lt.mapper;


import com.lt.pojo.AppInfo;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
* @author tjb28
* @description 针对表【app_info】的数据库操作Mapper
* @createDate 2024-05-13 17:42:32
* @Entity generator.domain.AppInfo
*/
@Repository
public interface AppInfoMapper {
    //手游类别条件查询
    List<AppInfo> selectAllByCondation(@Param("softwareName") String softwareName,@Param("status")Integer status,@Param("categoryLevel1")Integer categoryLevel1,@Param("categoryLevel2")Integer categoryLevel2,@Param("categoryLevel3")Integer categoryLevel3,@Param("devId")Integer devId,@Param("flatformId")Integer flatformId,@Param("from")Integer from,@Param("pageSize")Integer pageSize);

    //获取产品数量
    Integer getAppInfoCount(@Param("softwareName") String softwareName, @Param("status") Integer status, @Param("categoryLevel1") Integer categoryLevel1, @Param("categoryLevel2") Integer categoryLevel2, @Param("categoryLevel3") Integer categoryLevel3, @Param("flatformId") Integer flatformId, @Param("devId") Integer devId);


    List<AppInfo> select(@Param("appInfo") AppInfo appInfo);

    //查询总数量
    Integer selectTotalNumber();

    //获取商品详情
    AppInfo getAppInfo(@Param("id") Integer id,@Param("softwareName") String softwareName);

    AppInfo getAppInfoById(@Param("id") Integer id);

    //添加
    Integer add(AppInfo appInfo);

    //修改
    Integer modify(AppInfo appInfo);

    int update(AppInfo appInfo);

    int delAppInfoById(Integer id);


    int updateAppInfoStatus(@Param("status") Integer status,@Param("id") Integer id);
}
